SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

-- =============================================
-- Author:		Khanh.Le
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[AddNewBooking]
(  
			@PaymentID	INT
           ,@Phone			VARCHAR(50)
           ,@MobilePhone	VARCHAR(50)
           ,@CardNo			VARCHAR(50)
           ,@TotalPaid		DECIMAL(18,2)
           ,@CheckInDate	DATETIME
           ,@CheckOutDate	DATETIME
           ,@Status			INT
           ,@CardHolder		NVARCHAR(200)
           ,@CardNumber		VARCHAR(50)
           ,@RoomId			INT
           ,@CreatedDate	DATETIME
           ,@ModifiedDate	DATETIME
           ,@NumberOfRooms	INT
           ,@CategoryRoomID	INT
           ,@CustomerID		INT
           ,@HotelID		INT
)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	
INSERT INTO [dbo].[Bookings]
           ([PaymentID]
           ,[Phone]
           ,[MobilePhone]
           ,[CardNo]
           ,[TotalPaid]
           ,[CheckInDate]
           ,[CheckOutDate]
           ,[Status]
           ,[CardHolder]
           ,[CardNumber]
           ,[RoomId]
           ,[CreatedDate]
           ,[ModifiedDate]
           ,[NumberOfRooms]
           ,[CategoryRoomID]
           ,[CustomerID]
           ,[HotelID])
     VALUES(
			@PaymentID
           ,@Phone
           ,@MobilePhone
           ,@CardNo		
           ,@TotalPaid	
           ,@CheckInDate
           ,@CheckOutDate
           ,@Status	
           ,@CardHolder
           ,@CardNumber
           ,@RoomId		
           ,@CreatedDate
           ,@ModifiedDate
           ,@NumberOfRooms
           ,@CategoryRoomID
           ,@CustomerID	
           ,@HotelID)



END
GO
